package com.hsqn.mapper;

import com.hsqn.entity.HealthAndSafety;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface HealthAndSafetyMapper {

//    @Insert("INSERT INTO elderly(name,gender,birth_date,id_card,phone,address,emergency_contact,emergency_phone,health_status,interest_hobby,created_time,updated_time,create_by,update_by,status) VALUES(#{name},#{gender},#{birthdate},#{idcard},#{phone},#{address},#{emergencycontact},#{emergencyphone},#{healthstatus},#{interesthobby},#{createdtime},#{updatedtime},#{createby},#{updateby},#{status});
@Insert("INSERT INTO elderly(name, gender, birth_date, id_card, phone, address, emergency_contact, " +
        "emergency_phone, health_status, interest_hobby, created_time, updated_time, create_by, update_by, status) " +
        "VALUES(#{name}, #{gender}, #{birthDate}, #{idCard}, #{phone}, #{address}, #{emergencyContact}, " +
        "#{emergencyPhone}, #{healthStatus}, #{interestHobby}, #{createdTime}, #{updatedTime}, #{createBy}, #{updateBy}, #{status})")
    void Insertelderly(HealthAndSafety user);
}
